Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

Oracle PLSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) Character String Functions
4) Collections
5) Conversion Functions
6) Cursor
7) Date Timestamp Functions
8) Function Procedure Packages
9) Index
10) Insert Update Delete
11) Introduction
12) Large Objects
13) Linear Regression Functions
14) Miscellaneous Functions
15) Numerical Math Functions
16) Object Oriented
17) PL SQL Data Types
18) PL SQL Operators
19) PL SQL Programming
20) PL SQL Statements
21) Query Select
22) Regular Expressions Functions
23) Sequences
24) Set
25) SQL Data Types
26) SQL PLUS Session Environment
27) Statistical Functions
28) System Packages
29) System Tables Data Dictionary
30) Table
31) Table Joins
32) Transaction
33) Trigger
34) User Privilege
35) View
36) XML

Linear Regression Functions
1) For another equivalent test statistic
2) For average value of dependent (y) variables
3) For average value of independent (x) variables
4) For between degrees of freedom (DF)
5) For between sum of squares (SS)
6) For chi-square degrees of freedom
7) For chi-square significance level
8) For chi-square value
9) For degrees of freedom
10) For degrees of freedom (DF)
11) For F statistic
12) For mean square (MS) between
13) For mean square (MS) within
14) For one-tailed significance level
15) For other related test statistics
16) For significance level
17) For significance level for one-sided test
18) For significance level for two-sided test
19) For significance level of one-sided test
20) For significance level of two-sided test
21) For sum of cross-product xy
22) For sum of squares x
23) For sum of squares y
24) For the coefficient of determination (R-square)
25) For the number of observations
26) For the test statistic value
27) For the y-intercept of the line
28) For two-tailed significance level
29) For within degrees of freedom (DF)
30) For within sum of squares (SS)
31) REGR_AVGX returns the average of x after eliminating x and y pairs where either x or y is null
32) REGR_COUNT(salary, city) AS count
33) REGR_SLOPE(expr1, expr2) gives a least square regression line to a set of pairs of numbers
34) REGR_SYY(salary, city) AS syy
35) SELECT STATS_WSR_TEST(value, id, ONE_SIDED_SIG)
36) STATS_CROSSTAB(expr1, expr2, COHENS_K)
37) STATS_CROSSTAB(expr1, expr2, CONT_COEFFICIENT)
38) STATS_CROSSTAB(expr1, expr2, CRAMERS_V)
39) STATS_F_TEST(expr1, expr2, DF_DEN)
40) STATS_MODE(expr) returns the mode of a set of numbers
41) STATS_MW_TEST(expr1, expr2, STATISTIC)
42) STATS_T_TEST_INDEPU(expr1, expr2, STATISTIC)
43) Stats_T_Test_One
44) STATS_T_TEST_PAIRED(expr1, expr2, STATISTIC)
45) STATS_WSR_TEST(expr1, expr2, STATISTIC)
46) STDDEV([DISTINCT ALL] value) [OVER (analytic_clause)] returns the standard deviation value
47) STDDEV_SAMP(expr) [OVER(analytic_clause)] computes the cumulative sample standard deviation
48) Using the Linear Regression Functions
49) VAR_POP(expr) calculates the population variance
50) VAR_SAMP(expr) calculates the sample variance
51) VARIANCE([DISTINCT ALL] expr) gives the variance of all values of a group of rows